=VLOOKUP(D2;Sheet1!A:B;2;0)
=IF(A2="";"";INDEX(ARTIKLI!$A$1:$B$65000; MATCH(A2; ARTIKLI!$A$1:$A$65000;0);2))
=IF(A2="";"";INDEX(ARTIKLI!$A$1:$B$1048576; MATCH(A2; ARTIKLI!$A$1:$A$1048576;0);2))
=IF(B2="";"";INDEX(ARTIKLI!$A$1:$B$65000; MATCH(B2; ARTIKLI!$A$1:$A$65000;0);2))



=IF(A2="";"";INDEX(ZALIHA!$A$1:$B$30000; MATCH(A2; ZALIHA!$A$1:$A$30000;0);2))

=IF(B2="";"";INDEX(ZALIHA!$A$1:$B$30000; MATCH(B2; ZALIHA!$A$1:$A$30000;0);2))





=IF(A3="";"";INDEX([GR.xls]FrmMatNR!$C$1:$F$65000; MATCH(A3;[GR.xls]FrmMatNR!$C$1:$C$65000;0);3)
=IF(A3="";"";INDEX([GR.xls]FrmMatNR!$C$1:$F$65000; MATCH(A3;[GR.xls]FrmMatNR!$C$1:$C$65000;0);4)



[GR.xls]FrmMatNR!

=IF(A3="";"";INDEX('C:\1\[PROK.xls]FrmMatNR'!$C$1:$F$65000;MATCH(A3;'C:\1\[PROK.xls]FrmMatNR'!$C$1:$C$65000;0);3))
=IF(A3="";"";INDEX('C:\1\[PROK.xls]FrmMatNR'!$C$1:$F$65000;MATCH(A3;'C:\1\[PROK.xls]FrmMatNR'!$C$1:$C$65000;0);4))






=IF(B2="";"";INDEX(ID!$A$1:$B$65000; MATCH(B2; ID!$A$1:$A$65000;0);2))

=IF(G2="";"";INDEX(Pošte!$A$1:$B$65000; MATCH(G2; Pošte!$A$1:$A$65000;0);2))

=IF(G2="";"";INDEX(GradID!$A$1:$B$65000; MATCH(G2; GradID!$A$1:$A$65000;0);2))


=IF(A2="";"";INDEX(KS!$A$1:$B$65000; MATCH(A2; KS!$A$1:$A$65000;0);2))

=IF(A2="";"";INDEX(IS!$A$1:$B$65000; MATCH(A2; IS!$A$1:$A$65000;0);2))

=IF(A2="";"";INDEX(Radio!$A$1:$B$65000; MATCH(A2; Radio!$A$1:$A$65000;0);2))